<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePositionTable extends Migration
{
    /**
     * Run the migrations.
     *industry_id  行业id
     * name 行业名称
     * img 图片
     * is_hot 是否是热门(1是2否)
     * order 排序
     * @return void
     */
    public function up()
    {
        Schema::create('position', function (Blueprint $table) {
            $table->engine='InnoDB';
            $table->increments('position_id')->comment('职位id');//职位id
            $table->string('position_name',50)->comment('职位名称'); //职位名称
            $table->tinyInteger('nature_work')->comment('工作性质 1实习,2正式,3日结,4月结,5年薪');  //工作性质
            $table->string('address',100)->comment('地址');  //地址
            $table->integer('low')->comment('最低工资');  //最低工资
            $table->integer('high')->comment('最高工资');
            $table->tinyInteger('education')->comment('学历要求 1.初中2.高中3.大专4.本科');
            $table->integer('work_life')->comment('工作年限');
            $table->tinyInteger('job_category')->comment('职位类型');
            $table->integer('industry_id')->comment('行业id');
            $table->integer('number_recruits')->comment('招聘人数');
            $table->text('describe')->comment('描述');
            $table->integer('company_id')->comment('公司id');
            $table->tinyInteger('status')->comment('状态');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('position');
    }
}
